Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_1358

R_1358

OrgUnitGroup

LPriceListOrgUnitGroup

OrgUnitGroupID

 

 

R_1360

R_1360

BenefitPlanContract

PerfService

BenefitPlanContractID

 

 

R_1367

R_1367

Branch

BranchText

BranchID

 

 

R_1369

R_1369

CareTaker

LContractCareTaker

CareTakerID

 

 

R_1370

R_1370

Person

CareTaker

PersonID

 

 

R_1371

R_1371

CareTakerType

CareTakerTypeText

CareTakerTypeID

 

 

R_1374

R_1374

CareTaker

LCareTakerAddress

CareTakerID

 

 

R_1375

R_1375

Address

LCareTakerAddress

AddressID

 

 

R_1376

R_1376

Place

Address

PlaceID

 

 

R_1377

R_1377

PostOffice

Address

PostOfficeID

 

 

R_1378

R_1378

Voivodship

Address

VoivodshipID

 

 

R_1382

R_1382

Branch

Contractor

BranchID

 

 

R_1383

R_1383

Invoice

InvoiceItem

InvoiceID

 

 

R_1384

R_1384

PaymentType

Invoice

PaymentTypeID

 

 

R_1385

R_1385

PaymentPeriod

Invoice

PaymentPeriodID

 

 

R_1386

R_1386

PaymentTerm

Invoice

PaymentTermID

 

 

R_1387

R_1387

FirstPeriodPayment

Invoice

FirstPeriodPaymentID

 

 

R_1388

R_1388

InvoiceChangeRule

Invoice

InvoiceChangeRuleID

 

 

R_1391

R_1391

BidCalculationPeriod

InvoiceItem

BidCalculationPeriodID

 

 

R_1392

R_1392

CostCenter

InvoiceItem

CostCenterID

 

 

R_1393

R_1393

Place

InvoiceItem

PlaceID

 

 

R_1394

R_1394

PaymentType

InvoiceItem

PaymentTypeID

 

 

R_1395

R_1395

Currency

InvoiceItem

CurrencyID

 

 

R_1397

R_1397

DeviationAction

InvoiceItem

DeviationActionID

 

 

R_1401

R_1401

PaymentPeriod

PaymentPeriodText

PaymentPeriodID

 

 

R_1402

R_1402

PaymentTerm

PaymentTermText

PaymentTermID

 

 

R_1403

R_1403

FirstPeriodPayment

FirstPeriodPaymentText

FirstPeriodPaymentID

 

 

R_1404

R_1404

CostCenter

CostCenterText

CostCenterID

 

 

R_1405

R_1405

BidCalculationPeriod

BidCalculationPeriodText

BidCalculationPeriodID

 

 

R_1406

R_1406

DeviationAction

DeviationActionText

DeviationActionID

 

 

R_1410

R_1410

Contract

Invoice

ContractID

 

 

R_1411

R_1411

InvoiceItem

LBFInvoiceItem

InvoiceItemID

 

 

R_1412

R_1412

BenefitPlanContract

LBFInvoiceItem

BenefitPlanContractID

 

 

R_1413

R_1413

InvoiceProduction

Invoice

InvoiceProductionID

 

 

R_1414

R_1414

InvoiceProduction

InvoiceProductionText

InvoiceProductionID

 

 

R_1416

R_1416

OverLimitAction

LBenefitPlanContractLimit

OverLimitActionID

 

 

R_1418

R_1418

OverLimitAction

OverLimitActionText

OverLimitActionID

 

 

R_1426

R_1426

Contract

LBeneficiaryContr

ContractID

 

 

R_1427

R_1427

CardKind

CardCreationRules

CardKindID

 

 

R_1428

R_1428

CancelReason

LContractStatus

CancelReasonID

 

 

R_1434

R_1434

CareTaker

LBenefitPlanContrBeneficiary

CareTakerID

 

 

R_1441

R_1441

ServiceGroupType

ServiceGroupTypeText

ServiceGroupTypeID

 

 

R_1442

R_1442

ServiceGroupType

ServiceGroup

ServiceGroupTypeID

 

 

R_1444

R_1444

BeneficiaryStatus

Beneficiary

BeneficiaryStatusID

 

 

R_1449

R_1449

OrgUnitGroup

LPriceListMedResOrgUnitGroup

OrgUnitGroupID

 

 

R_1450

R_1450

MedResource

LPriceListMedResOrgUnitGroup

MedResourceID

 

 

R_1451

R_1451

PriceList

LPriceListMedResOrgUnitGroup

PriceListID

 

 

R_1465

R_1465

Contact

LContractContact

ContactID

 

 

R_1466

R_1466

Contract

LContractContact

ContractID

 

 

R_1468

R_1468

PaymentTitle

InvoiceItem

PaymentTitleID

 

 


1  2  3  4